DETEX 17852

Selected

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Price'.

The error occurred in C:/websites/Piragis/functions/category.cfc: line 701
Called from C:/websites/Piragis/includes/sidenav.cfm: line 372
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 215
Called from C:/websites/Piragis/category.cfm: line 212
Called from C:/websites/Piragis/category.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 1
Called from C:/websites/Piragis/functions/category.cfc: line 701
Called from C:/websites/Piragis/includes/sidenav.cfm: line 372
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 215
Called from C:/websites/Piragis/category.cfm: line 212
Called from C:/websites/Piragis/category.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 1

699 : 		<!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
700 : 		<Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
701 : 			<cfloop list="#application.filterList#" index="listItem">
702 : 				<cfif len(url[listItem])  and listItem neq "Keyword">
703 : 					<cfif listItem eq "Team">

SQLSTATE	42S22
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	celerantSQL
VENDORERRORCODE	207
SQL	SELECT distinct dept, count(*) as itemCount FROM web_all_products WHERE dept<>'EMPTY' and upper(pricerange)='10-to-15' and upper(Price)='10-to-15' and upper(Brand)='DETEX 17852' GROUP BY dept

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	172.69.58.251
Referrer	https://boundarywaterscatalog.com/all-products/browse/price/10-to-15/orderby/name-a-to-zor%201=1%20and%20ifnullasciisubstringselect%20@@version,1,1,0=1/brand/detex-17852
Date/Time	19-Sep-24 12:40 PM

Stack Trace

at cfcategory2ecfc526974322$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Piragis/functions/category.cfc:701) at cfsidenav2ecfm1454639160._factor10(C:/websites/Piragis/includes/sidenav.cfm:372) at cfsidenav2ecfm1454639160._factor11(C:/websites/Piragis/includes/sidenav.cfm:1) at cfsidenav2ecfm1454639160.runPage(C:/websites/Piragis/includes/sidenav.cfm:1) at cfcategory2ecfm208948898._factor5(C:/websites/Piragis/category.cfm:215) at cfcategory2ecfm208948898._factor7(C:/websites/Piragis/category.cfm:212) at cfcategory2ecfm208948898._factor8(C:/websites/Piragis/category.cfm:1) at cfcategory2ecfm208948898.runPage(C:/websites/Piragis/category.cfm:1) at cfcategory2ecfc526974322$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Piragis/functions/category.cfc:701) at cfsidenav2ecfm1454639160._factor10(C:/websites/Piragis/includes/sidenav.cfm:372) at cfsidenav2ecfm1454639160._factor11(C:/websites/Piragis/includes/sidenav.cfm:1) at cfsidenav2ecfm1454639160.runPage(C:/websites/Piragis/includes/sidenav.cfm:1) at cfcategory2ecfm208948898._factor5(C:/websites/Piragis/category.cfm:215) at cfcategory2ecfm208948898._factor7(C:/websites/Piragis/category.cfm:212) at cfcategory2ecfm208948898._factor8(C:/websites/Piragis/category.cfm:1) at cfcategory2ecfm208948898.runPage(C:/websites/Piragis/category.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Price'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1085)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1585)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfcategory2ecfc526974322$funcGETDEPARTMENTFILTER.runFunction(C:\websites\Piragis\functions\category.cfc:701)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4254)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217)
	at cfsidenav2ecfm1454639160._factor10(C:\websites\Piragis\includes\sidenav.cfm:372)
	at cfsidenav2ecfm1454639160._factor11(C:\websites\Piragis\includes\sidenav.cfm:1)
	at cfsidenav2ecfm1454639160.runPage(C:\websites\Piragis\includes\sidenav.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201)
	at cfcategory2ecfm208948898._factor5(C:\websites\Piragis\category.cfm:215)
	at cfcategory2ecfm208948898._factor7(C:\websites\Piragis\category.cfm:212)
	at cfcategory2ecfm208948898._factor8(C:\websites\Piragis\category.cfm:1)
	at cfcategory2ecfm208948898.runPage(C:\websites\Piragis\category.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)

DETEX 17852

Selected

Category

Error Executing Database Query.